Updating prices and adding new parts simultaneously

To update prices and add new parts simultaneously:

1. Open 9-6 Add Parts/Update Prices.
2. Select Add New Parts.
   1. If you want to automatically assign part numbers to the imported parts, select Assign Part#.
   2. In the Start# text box, enter the starting number to assign to the new parts. This must be in numeric form only.
3. Select Update Part Prices and complete the following as necessary:
   1. If you want Sage 100 Contractor to match parts based on the Alpha Part#, select Match Alpha Part#.

4. Default Cost/Billing Amount is selected by default.

   Note: Vendor-specific prices will not be applied to new parts but will be applied to Default Cost/Billing Amount. Sage 100 Contractor updates the default cost/billing amount for parts in the database.

   1. If you want Sage 100 Contractor to update the Vendor Price instead of the Default Cost/Billing Amount in the 9-2 Parts window, select Vendor Price.
   2. If you have selected Vendor Price as your update method, select from the drop-down list the vendor whose source file you are using.
5. Choose Select Source File, browse, and then select the database file to use for adding parts. The path name for the source file appears in the window.
   1. The Source File Fields under Field Mapping appears.

   2. If the source file contains descriptive headers or labels as its first line, select First Line is Header.

      This line is ignored during the add/update function.

6. Map which Destination Fields from the Sage 100 Contractor database correspond to the imported Source File Fields.
   1. On the left side of the window, under Field Mapping, select the Source File Fields row and the Destination Fields cell that you want to map.

   2. Under Destination Fields on the right side of the window, select the corresponding Sage 100 Contractor field and click the left arrow key. Alternately, select the Sage 100 Contractor field, and then select ENTER. Alternatively, you can double-click the field.

      Important! At minimum, you must select Part#, Description, and Unit as Destination Fields to be mapped.

      The part numbers from the vendor's source file must match the Part# in Sage 100 Contractor in order for the update to properly occur.

7. Repeat step 6 until you have mapped all fields you want to import to Sage 100 Contractor from the external database.

8. Click Add/Update.

   If any failures occur during the process, an error log appears for your review.